c.t_id=d.t_id left joins student A on a.s_id=b.s_id where D.tname= ' Zhang San '; /*dense_rank () */select E.s_id,e.c_id,e.score from (select s_id, c_id, Score,dense_rank () over (partition by c_id ORDER BY s_id) Rank1 from SC) e left joins course C on e.c_id=c.c_id left joins teacher D on c.t_id=d.t_id where D.tname= ' Zhang San '
and e.rank1=1; Select Top 1* from (select s_id, c_id, Score,dense_rank () up (partition by c_id ORDER by s_id) Rank1 from SC E left J
Oin course C on e.c_id=c
Recently learned SQL in Teradata environment. Here to record the study of the knowledge points, as a record.Directory:
About SQL learning and the online database used
Table Union (join)
SQL Sub-query
Create a new field at select (as, Case time)
Data Grouping (group BY + aggregate function count
"annual Salary"From EMP ORDER by 3 DESC;SELECT ename,job,sal from emp ORDER by Job,sal DESC;SELECT ename,job,sal from emp ORDER by Empno;Modify Default display widthSET line[size] {80|n}SET Line 100L display the SQL statement in the buffer you just enteredN Text modified section of error'/' (run) commandSAVEGET@ or Start command when the specified script file contents are loaded into the SQL buffer to runS
Label:Original: SQL Server Performance Tuning Training IntroductionHello everybody, this is the first blog post I wrote in the blogging park, and the reason I want to open this blog is a record of my interest in MS SQL Technology learning. As a computer professional graduates, their own grasp of the technology always feel very superficial, Bo and not specialized
appliedPARTITION by ParametersDivides the result set into multiple partitions. The window functions are applied to each partition separately, and the calculation is restarted for each partition.Cases:Select Orderid,custid,val,Sum (val) over () as Totalvalue,Sum (val) over (partition by CustID) as CusttotalvalFrom OrdervaluesQuery Result:
OrderID
CustID
Val
Totalvalue
Custtotalval
10001
1
800.50
1232323.23
4343.00
Oracle SQL Language DDL and Object Management-beyond OCP proficient in Oracle Video tutorial training 27This course introduces:Oracle Video tutorial, wind Brother this set of Oracle Tutorial training is the Oracle SQL language DDL and Object management, the course content is detailed as follows:Describes table schema o
Label:Poptest is the only training institute for developing Test and development engineers in China, aiming at the ability of the trainees to be competent in automated testing, performance testing and testing tools development. In Poptest's LoadRunner training, in order to improve the performance of students experience, add a lot of server optimization knowledge, for performance tuning ability to lay the fo
Tags: SQL query statement SQL statement SQL Tutorial SQL language SQL database tutorialOracle SQL Language Foundation and Environment readiness-beyond OCP proficient Oracle Video Tutorial Trai
Tags: Oracle training Oracle Video Oracle Database tutorial Oracle Video Tutorial Oracle Video tutorial goals NBSP;NBSP;NBSP; Oracle video tutorial, wind Brother this set of Oracle Tutorial Training learning Oracle Sql*loader Concepts and usage and sql* Loader two cases, while the courseware with nearly 20 cases for e
Tags: SQL query statement SQL Tutorial SQL language SQL database tutorialOracle SQL Language Query statement-beyond OCP proficient in Oracle video tutorial training 29This course introduces:Oracle Video tutorial, wind Brother this
Tags: MCTThe following series of official training courseware for SQL Server 2014 has been released.The required MCT (Microsoft Certified Instructor) can download these courseware by logging in to the official HTTPS://MOCL.ONE.MICROSOFT.COM/CWDL ID.10977b:updating Your SQL Server Skills to Microsoft SQL Server 20142046
the SQL Server Management platform, and Transact-SQL statements,---to show the number of students, their names, and the amount of courses each student learns. alter view Select distinct b. School Number , name , number of courses from (Select Study number , count( number ) course number from V_stu_c group by study number ) as a( number of courses ),V_stu_c b where a. Study number =b. School Number ---(1
, restore the transaction log backup after the differential backup is restored (if you don't have a differential backup after the last full backup), again, don't forget the no recovery. It's really bad to do all this with a graphical interface. The more backups you make, the longer you restore and the more error-prone. Instead, you need a script to manage the backup folder, find the corresponding file, and make an automatic reply.In the following training
The following series of official training courseware for SQL Server 2014 has been released.The required MCT (Microsoft Certified Instructor) can download these courseware with the MCP ID on the official website HTTPS://MOCL.ONE.MICROSOFT.COM/CWDL. Https://www.microsoft.com/learning/en-us/help.aspx10977b:updating Your SQL Server Skills to Microsoft
Oracle SQL language DML statements and transactions _ Beyond OCP proficient Oracle Video Tutorial Training 28This course introduces:Oracle Video tutorial, wind Brother this set of Oracle Tutorial training is the Oracle SQL language DML statements and transaction management, the course content is detailed as follows:Lea
displayed. This field can only use less than or less than or equal, cannot use greater than or greater than equals.If pagination can only be queried first rownum this column select RowNum from EMP, and then from here rownum> or Select RowNum, ename from (select RowNum No from emp) T where no>3 and no--The 6th to 10th employee of the highest salarySelect Ename,sal from (select Ename,sal,rownum r from (select Ename,sal from emp order by sal Desc)) where r>=6 and r lt;=10;--For the last 5 employee
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.